In [7]:
import pandas as pd  
dataset = pd.read_csv("C:/Users/ROHIT/Documents/ok.csv")
In [8]:
dataset
Out[8]:
State District Year NumberOfCrimes CrimeType CrimeGroup Region
0 Andhra Pradesh Adilabad 2001 178 MURDER HOMICIDE SOUTH
1 Andhra Pradesh Anantapur 2001 277 MURDER HOMICIDE SOUTH
2 Andhra Pradesh Chittoor 2001 160 MURDER HOMICIDE SOUTH
3 Andhra Pradesh Cuddapah 2001 134 MURDER HOMICIDE SOUTH
4 Andhra Pradesh East Godavari 2001 150 MURDER HOMICIDE SOUTH
... ... ... ... ... ... ... ...
203903 Jammu and Kashmir Srinagar 2014 0 MURDER HOMICIDE NORTH
203904 Jammu and Kashmir Srinagar 2014 0 KIDNAPPING & ABDUCTION KIDNAPPING & ABDUCTION NORTH
203905 Jammu and Kashmir Srinagar 2014 0 OTHER IPC CRIMES OTHERS NORTH
203906 Jammu and Kashmir Srinagar 2014 0 AUTO THEFT PROPERTY STOLEN NORTH
203907 Jammu and Kashmir Srinagar 2014 0 CHEATING SERIOUS FRAUD NORTH

203908 rows × 7 columns

In [9]:
import numpy as np
import matplotlib.pyplot as plt
%matplotlib inline
from matplotlib import style
In [10]:
df = dataset.groupby('State',as_index=False)[['NumberOfCrimes']].sum()
state = df['State']
crime = df['NumberOfCrimes']
In [11]:
Ypts = np.arange(len(crime))
In [12]:
import plotly.express as px
fig = px.bar(df, x="NumberOfCrimes", y="State", orientation='h')
fig.show()
In [13]:
import plotly.express as px
df = dataset.groupby('Year',as_index=False)[['NumberOfCrimes']].sum()
px.treemap(data_frame=df,path=['Year'],values='NumberOfCrimes',color='NumberOfCrimes',color_continuous_scale='rdbu')
In [14]:
df = dataset.groupby('Region',as_index=False)[['NumberOfCrimes']].sum()
df
Out[14]:
Region NumberOfCrimes
0 ARABIAN SEA 858
1 BAY OF BENGAL 10217
2 CENTRAL 3540124
3 EAST 4473617
4 NORTH 7203585
5 NORTH-EAST 1001489
6 SOUTH 8264146
7 WEST 4410987
In [15]:
x = df['Region'].values
y = df['NumberOfCrimes'].values
z = df.index
In [16]:
import plotly.express as px
fig = px.scatter(df,x="Region", y="NumberOfCrimes",
                size="NumberOfCrimes", color="Region",
                    hover_name=df.index,size_max=60)
fig.show()
In [17]:
df = dataset.groupby('District',as_index=False)[['NumberOfCrimes']].sum()
names = df['District']
values = df['NumberOfCrimes']
In [18]:
fig = px.pie(df,
            names = names,
            values = values,
            title = 'District wise crimes'
            )

fig.update_traces(
            textposition = 'inside',
            textinfo = 'percent+label'
            )

fig.update_layout(
            title_font_size = 42
            )

fig.show()